1100 |
Is it is possible to exclude the non-working days when displaying the histogram using the exBarEffort for exHistOverAllocation type
Dim h as N Dim oG2antt as P Dim var_Bar as P Dim var_Bar1 as P Dim var_Bar2 as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 ' var_Chart.PaneWidth(.f.) = 40 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 40" var_Chart.FirstVisibleDate = {06/20/2005} var_Chart.HistogramVisible = .t. var_Chart.HistogramHeight = 64 var_Chart.HistogramView = 112 var_Bar = var_Chart.Bars.Item("Split") var_Bar.Pattern = 6 var_Bar.Shape = 18 var_Bar.Color = 8388608 var_Bar1 = var_Chart.Bars.Add("Task:Split") var_Bar1.Color = 8388608 var_Bar1.Shortcut = "WorkingTask" var_Bar1.Pattern = 6 var_Bar1.HistogramPattern = 6 var_Bar1.HistogramType = 1 var_Bar2 = var_Chart.Bars.Item("Task") var_Bar2.Color = 16711680 var_Bar2.Pattern = 5 var_Bar2.HistogramType = 1 var_Bar2.HistogramPattern = 5 var_Items = oG2antt.Items h = var_Items.AddItem("True") var_Items.AddBar(h,"WorkingTask",{06/23/2005},{06/29/2005}) ' var_Items.ItemBar(h,"",21) = 4 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,``,21) = 4" ' var_Items.ItemBar(h,"",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,``,20) = True" h = var_Items.AddItem("False") var_Items.AddBar(h,"Task",{06/23/2005},{06/29/2005}) ' var_Items.ItemBar(h,"",21) = 4 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,``,21) = 4" ' var_Items.ItemBar(h,"",20) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,``,20) = False" oG2antt.EndUpdate() |
1099 |
I display numbers in my chart, but the AddBar requires a date how can I add a bar
Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.NonworkingDays = 0 var_Chart.FirstVisibleDate = 0 var_Chart.ToolTip = "" var_Level = var_Chart.Level(0) var_Level.Label = "<%i%>" var_Level.ToolTip = "" var_Chart.UnitWidth = 24 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2,4) var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",6,10) oG2antt.EndUpdate() |
1098 |
I display numbers in the chart's header but do not want to get displayed negative numbers. How can i do that
' Occurs when the first visible date is changed. function DateChange as v () oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Chart.FirstVisibleDate = 0 oG2antt.Template = "ScrollPartEnable(2,1024) = False" // oG2antt.ScrollPartEnable(2,1024) = .f. end function Dim oG2antt as P Dim var_Chart as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.NonworkingDays = 0 var_Chart.FirstVisibleDate = 0 var_Chart.ToolTip = "" var_Level = var_Chart.Level(0) var_Level.Label = "<%i%>" var_Level.ToolTip = "<%i%>" var_Chart.UnitWidth = 24 oG2antt.EndUpdate() |
1097 |
How can I display numbers in the chart's header instead dates
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.NonworkingDays = 0 var_Chart.FirstVisibleDate = 0 var_Chart.ToolTip = "" var_Level = var_Chart.Level(0) var_Level.Label = "<%i%>" var_Level.ToolTip = "" var_Chart.UnitWidth = 24 oG2antt.EndUpdate() |
1096 |
How can I create a bar that's not sizable, or can not be resized by default similar with milestone
Dim oG2antt as P Dim var_Bar as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {12/24/2000} var_Chart.LevelCount = 2 var_Bar = var_Chart.Bars.Add("Custom") var_Bar.Shape = 0 var_Bar.StartShape = 1 var_Bar.EndShape = 0 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem(""),"Custom",{01/02/2001},{01/02/2001},"K1","This TYPE of bar can not be resized.") oG2antt.EndUpdate() |
1095 |
Is it possible to hide the non-working parts for items using the ItemNonworkingUnits, even if set the ShowNonworkingUnits, ShowNonworkingDates on False
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/27/2000} ' var_Chart.PaneWidth(.f.) = 64 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 64" var_Chart.LevelCount = 2 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. var_Chart.NonworkingDaysPattern = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") ' var_Items.ItemNonworkingUnits(h2,.f.) = "weekday(value) = 1" oG2antt.TemplateDef = "dim var_Items,h2" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h2 oG2antt.Template = "var_Items.ItemNonworkingUnits(h2,False) = `weekday(value) = 1`" var_Items.AddBar(h2,"Task",{01/04/2001},{01/06/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/08/2001},{01/10/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") oG2antt.EndUpdate() |
1094 |
Is it possible to show the non-working parts for certain items, even if I hide the default non-working part
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/27/2000} ' var_Chart.PaneWidth(.f.) = 64 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 64" var_Chart.LevelCount = 2 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") ' var_Items.ItemNonworkingUnits(h2,.f.) = "weekday(value) = 1" oG2antt.TemplateDef = "dim var_Items,h2" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h2 oG2antt.Template = "var_Items.ItemNonworkingUnits(h2,False) = `weekday(value) = 1`" var_Items.AddBar(h2,"Task",{01/04/2001},{01/06/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/08/2001},{01/10/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") oG2antt.EndUpdate() |
1093 |
How can I hide the non-working part of the chart
Dim oG2antt as P Dim var_Chart as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2008} ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.LevelCount = 2 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. oG2antt.EndUpdate() |
1092 |
Is it possible to let users selects cells as in Excel
Dim h as N Dim h1 as N Dim oG2antt as P Dim var_Column as P Dim var_Column1 as P Dim var_Column2 as P Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.FullRowSelect = 1 oG2antt.SingleSel = .f. oG2antt.ReadOnly = -1 oG2antt.MarkSearchColumn = .f. oG2antt.ShowFocusRect = .f. oG2antt.LinesAtRoot = -1 oG2antt.SelForeColor = 0 oG2antt.SelBackColor = 15917512 var_Columns = oG2antt.Columns var_Columns.Add("A") var_Column = var_Columns.Add("B") var_Column.AllowSizing = .f. var_Column.Width = 24 var_Column1 = var_Columns.Add("C") var_Column1.AllowSizing = .f. var_Column1.Width = 24 ' var_Column1.Def(0) = 1 oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Def(0) = 1" var_Column1.PartialCheck = .t. var_Column2 = var_Columns.Add("D") var_Column2.AllowSizing = .f. var_Column2.Width = 24 ' var_Column2.Def(1) = 1 oG2antt.TemplateDef = "dim var_Column2" oG2antt.TemplateDef = var_Column2 oG2antt.Template = "var_Column2.Def(1) = 1" var_Items = oG2antt.Items h = var_Items.InsertItem(,,"Group 1") h1 = var_Items.InsertItem(h,,16) ' var_Items.CellValue(h1,1) = 17 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 17" h1 = var_Items.InsertItem(h,,2) ' var_Items.CellValue(h1,1) = 11 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 11" h1 = var_Items.InsertItem(h,,2) ' var_Items.ItemBackColor(h1) = 15790320 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBackColor(h1) = 15790320" ' var_Items.CellValue(h1,1) = 9 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 9" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.InsertItem(,,"Group 2") ' var_Items.CellValueFormat(h,2) = 1 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValueFormat(h,2) = 1" h1 = var_Items.InsertItem(h,,16) ' var_Items.CellValue(h1,1) = 9 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 9" h1 = var_Items.InsertItem(h,,12) ' var_Items.CellValue(h1,1) = 11 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 11" h1 = var_Items.InsertItem(h,,2) ' var_Items.CellValue(h1,1) = 2 oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.CellValue(h1,1) = 2" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" ' var_Items.SelectItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.SelectItem(h) = True" oG2antt.EndUpdate() |
1091 |
How can I hide a date from the chart view
Dim oG2antt as P Dim var_Chart as P Dim var_InsideZooms as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2008} ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.LevelCount = 2 var_Chart.AllowInsideZoom = .t. var_Chart.AllowResizeInsideZoom = .f. var_Chart.InsideZoomOnDblClick = .f. var_InsideZooms = var_Chart.InsideZooms var_InsideZooms.SplitBaseLevel = .f. var_InsideZooms.DefaultWidth = 0 var_InsideZooms.Add({01/04/2008}) var_InsideZooms.Add({01/05/2008}) var_InsideZooms.Add({01/06/2008}) var_Chart.SelectLevel = 1 ' var_Chart.SelectDate({01/05/2008}) = .t. oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.SelectDate(#1/5/2008#) = True" oG2antt.EndUpdate() |
1090 |
Can the SchedulePDM displays and edit the working units for my bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Column as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Items.AllowCellValueToItemBar = .t. oG2antt.Columns.Add("Task") var_Column = oG2antt.Columns.Add("Working") ' var_Column.Def(18) = 258 oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(18) = 258" var_Column.Editor.EditType = 4 var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 96 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 96" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"") var_Items.AddLink("L1",h1,"",h2,"") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"") var_Items.AddLink("L2",h2,"",h3,"") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"") var_Items.AddLink("L3",h4,"",h3,"") ' var_Items.ItemBar(0,"<*>",20) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,20) = True" var_Items.SchedulePDM(var_Items.FirstVisibleItem,"") oG2antt.EndUpdate() |
1089 |
Can the SchedulePDM displays the working units for my bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Column as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Items.AllowCellValueToItemBar = .t. oG2antt.Columns.Add("Task") ' oG2antt.Columns.Add("Working").Def(18) = 258 var_Column = oG2antt.Columns.Add("Working") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(18) = 258" var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 96 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 96" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"") var_Items.AddLink("L1",h1,"",h2,"") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"") var_Items.AddLink("L2",h2,"",h3,"") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"") var_Items.AddLink("L3",h4,"",h3,"") ' var_Items.ItemBar(0,"<*>",20) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,20) = True" var_Items.SchedulePDM(var_Items.FirstVisibleItem,"") oG2antt.EndUpdate() |
1088 |
Can the SchedulePDM keeps the working units for my bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"K4") var_Items.AddLink("L3",h4,"K4",h3,"K3") ' var_Items.ItemBar(0,"<*>",20) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,20) = True" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1087 |
How can I arrange automatically the bars based on their links as soon as user moves the bars
' Occurs when a bar is moving or resizing. function BarResizing as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim h4 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" h4 = var_Items.AddItem("Task 4") var_Items.AddBar(h4,"Task",{01/02/2001},{01/04/2001},"K4") var_Items.AddLink("L3",h4,"K4",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1086 |
How can I arrange automatically the bars based on their links as soon as user moves the bars
' Occurs when a bar is moved or resized. function BarResize as v (Item as OLE::Exontrol.G2antt.1::HITEM,Key as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Items.SchedulePDM(Item,Key) end function Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.AllowLinkBars = .f. var_Chart.AllowCreateBar = 0 var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1085 |
I have some buttons added on the control's scroll bar, how can I can know when the button is being clicked
' Occurs when the user clicks a button in the scrollbar. function ScrollButtonClick as v (ScrollBar as OLE::Exontrol.G2antt.1::ScrollBarEnum,ScrollPart as OLE::Exontrol.G2antt.1::ScrollPartEnum) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? ScrollBar ? ScrollPart end function Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Template = "ScrollPartVisible(1,32768) = True" // oG2antt.ScrollPartVisible(1,32768) = .t. oG2antt.Template = "ScrollPartVisible(1,16384) = True" // oG2antt.ScrollPartVisible(1,16384) = .t. oG2antt.Template = "ScrollPartVisible(1,1) = True" // oG2antt.ScrollPartVisible(1,1) = .t. oG2antt.Template = "ScrollPartVisible(1,2) = True" // oG2antt.ScrollPartVisible(1,2) = .t. oG2antt.ScrollBars = 5 |
1084 |
How do I get notified once the user clicks a hyperlink created using the anchor HTML tag
' Occurs when an anchor element is clicked. function AnchorClick as v (AnchorID as C,Options as C) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? AnchorID ? Options end function Dim oG2antt as P Dim var_Column as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Default").Def(17) = 1 var_Column = oG2antt.Columns.Add("Default") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(17) = 1" var_Items = oG2antt.Items var_Items.AddItem("This is a link: <aex.com;1>www.exontrol.com</a>") var_Items.AddItem("This is a link: <aex.net;2>www.exontrol.net</a>") |
1083 |
Is it possible to start editing a cell when double click it
' Occurs when the user dblclk the left mouse button over an object. function DblClick as v (Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Edit() end function Dim oG2antt as P Dim var_Editor as local Dim var_Editor1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.AutoEdit = .f. oG2antt.MarkSearchColumn = .f. ' oG2antt.Columns.Add("Edit1").Editor.EditType = 1 var_Editor = oG2antt.Columns.Add("Edit1").Editor oG2antt.TemplateDef = "dim var_Editor" oG2antt.TemplateDef = var_Editor oG2antt.Template = "var_Editor.EditType = 1" ' oG2antt.Columns.Add("Edit2").Editor.EditType = 1 var_Editor1 = oG2antt.Columns.Add("Edit2").Editor oG2antt.TemplateDef = "dim var_Editor1" oG2antt.TemplateDef = var_Editor1 oG2antt.Template = "var_Editor1.EditType = 1" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(3),1) = 4 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(3),1) = 4" oG2antt.EndUpdate() |
1082 |
Is it possible to disable standard single-click behavior for this column, so I manually could call Edit() when needed
' Occurs when the user dblclk the left mouse button over an object. function DblClick as v (Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Edit() end function Dim oG2antt as P Dim var_Editor as local Dim var_Editor1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.AutoEdit = .f. oG2antt.MarkSearchColumn = .f. ' oG2antt.Columns.Add("Edit1").Editor.EditType = 1 var_Editor = oG2antt.Columns.Add("Edit1").Editor oG2antt.TemplateDef = "dim var_Editor" oG2antt.TemplateDef = var_Editor oG2antt.Template = "var_Editor.EditType = 1" ' oG2antt.Columns.Add("Edit2").Editor.EditType = 1 var_Editor1 = oG2antt.Columns.Add("Edit2").Editor oG2antt.TemplateDef = "dim var_Editor1" oG2antt.TemplateDef = var_Editor1 oG2antt.Template = "var_Editor1.EditType = 1" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(3),1) = 4 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(3),1) = 4" oG2antt.EndUpdate() |
1081 |
How can I get or restore the old or previously value for the cell being changed
' Occurs when the user changes the cell's content. function Change as v (Item as OLE::Exontrol.G2antt.1::HITEM,ColIndex as N,NewValue as A) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? "Old-Value:" ? oG2antt.Items.CellValue(Item,ColIndex) ? "New-Value:" ? NewValue end function Dim oG2antt as P Dim var_Editor as local Dim var_Editor1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.MarkSearchColumn = .f. ' oG2antt.Columns.Add("Edit1").Editor.EditType = 1 var_Editor = oG2antt.Columns.Add("Edit1").Editor oG2antt.TemplateDef = "dim var_Editor" oG2antt.TemplateDef = var_Editor oG2antt.Template = "var_Editor.EditType = 1" ' oG2antt.Columns.Add("Edit2").Editor.EditType = 1 var_Editor1 = oG2antt.Columns.Add("Edit2").Editor oG2antt.TemplateDef = "dim var_Editor1" oG2antt.TemplateDef = var_Editor1 oG2antt.Template = "var_Editor1.EditType = 1" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(3),1) = 4 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(3),1) = 4" oG2antt.EndUpdate() |
1080 |
How can I display the number of items being found after filtering
' Occurs when the filter was changed. function FilterChange as v () oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.FilterBarCaption = oG2antt.Items.VisibleCount end function Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 1 oG2antt.FilterBarPromptPattern = "london" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1079 |
How can I highligth the item from the cursor as it moves
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) Dim h as N Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() h = oG2antt.ItemFromPoint(-1,-1,c,hit) var_Items = oG2antt.Items var_Items.ClearItemBackColor(oG2antt.Background(1000 '200 + exHSRight + exListOLEDropPosition)) ' var_Items.ItemBackColor(h) = 15792880 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBackColor(h) = 15792880" oG2antt.Template = "Background(1000) = h" // oG2antt.Background(1000 '200 + exHSRight + exListOLEDropPosition) = h oG2antt.EndUpdate() end function Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = 1 oG2antt.SelBackColor = 15792880 oG2antt.SelForeColor = 0 oG2antt.ShowFocusRect = .f. var_Chart = oG2antt.Chart var_Chart.SelBackColor = 15792880 oG2antt.Columns.Add("Items") var_Items = oG2antt.Items h = var_Items.AddItem("R1") var_Items.InsertItem(h,,"Cell 1.1") var_Items.InsertItem(h,,"Cell 1.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"Cell 2.1") var_Items.InsertItem(h,,"Cell 2.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1078 |
How can I get the item from the cursor
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) Dim h as N oG2antt = topparent:CONTROL_ACTIVEX1.activex h = oG2antt.ItemFromPoint(-1,-1,c,hit) ? "Handle" ? h ? "Index" ? oG2antt.Items.ItemToIndex(h) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = 1 oG2antt.Columns.Add("Items") var_Items = oG2antt.Items h = var_Items.AddItem("R1") var_Items.InsertItem(h,,"Cell 1.1") var_Items.InsertItem(h,,"Cell 1.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"Cell 2.1") var_Items.InsertItem(h,,"Cell 2.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1077 |
How can I get the column from the cursor, not only in the header
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? oG2antt.ColumnFromPoint(-1,0) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("P1") oG2antt.Columns.Add("P2") oG2antt.DrawGridLines = -1 var_Items = oG2antt.Items h = var_Items.AddItem("R1") ' var_Items.CellValue(h,1) = "R2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `R2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 1.1"),1) = "Cell 1.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 1.1`),1) = `Cell 1.2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 2.1"),1) = "Cell 2.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 2.1`),1) = `Cell 2.2`" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1076 |
How can I get the column from the cursor
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) oG2antt = topparent:CONTROL_ACTIVEX1.activex ? oG2antt.ColumnFromPoint(-1,-1) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = -1 oG2antt.Columns.Add("P1") oG2antt.Columns.Add("P2") var_Items = oG2antt.Items h = var_Items.AddItem("R1") ' var_Items.CellValue(h,1) = "R2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `R2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 1.1"),1) = "Cell 1.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 1.1`),1) = `Cell 1.2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 2.1"),1) = "Cell 2.2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 2.1`),1) = `Cell 2.2`" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1075 |
How can I get the cell's caption from the cursor
' Occurs when the user moves the mouse. function MouseMove as v (Button as N,Shift as N,X as OLE::Exontrol.G2antt.1::OLE_XPOS_PIXELS,Y as OLE::Exontrol.G2antt.1::OLE_YPOS_PIXELS) Dim h as N oG2antt = topparent:CONTROL_ACTIVEX1.activex h = oG2antt.ItemFromPoint(-1,-1,c,hit) ? oG2antt.Items.CellCaption(h,c) end function Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("Items") var_Items = oG2antt.Items h = var_Items.AddItem("R1") var_Items.InsertItem(h,,"Cell 1.1") var_Items.InsertItem(h,,"Cell 1.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"Cell 2.1") var_Items.InsertItem(h,,"Cell 2.2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.EndUpdate() |
1074 |
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 33 'exGridLinesVSolid + exGridLinesHDot4 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") oG2antt.Columns.Add("C3") var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") ' var_Items.CellValue(h,1) = "SubItem 1.2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `SubItem 1.2`" ' var_Items.CellValue(h,2) = "SubItem 1.3" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,2) = `SubItem 1.3`" h = var_Items.AddItem("Item 2") ' var_Items.CellValue(h,1) = "SubItem 2.2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `SubItem 2.2`" ' var_Items.CellValue(h,2) = "SubItem 2.3" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,2) = `SubItem 2.3`" oG2antt.EndUpdate() |
1073 |
How can I show the bars over the grid lines, i.e. so you cannot see the grid lines 'through' the bar
Dim h as N Dim oG2antt as P Dim var_Bar as P Dim var_Chart as P Dim var_Items as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.DrawGridLines = -1 oG2antt.GridLineColor = 14474460 var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 48" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 256 var_Chart.LevelCount = 2 var_Level = var_Chart.Level(1) var_Level.DrawGridLines = .t. var_Level.GridLineColor = 14474460 var_Bar = var_Chart.Bars.Item("Task") var_Bar.Pattern = 1 var_Bar.Height = 14 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/05/2001},"A") var_Items.AddBar(h,"Task",{01/08/2001},{01/15/2001},"B") oG2antt.EndUpdate() |
1072 |
Is it possible to change the style for the vertical grid lines, in the chart area only
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as local Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 12 var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 48" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 12 var_Chart.LevelCount = 2 ' var_Chart.Level(1).DrawGridLines = .t. var_Level = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.DrawGridLines = True" var_Level1 = var_Chart.Level(0) var_Level1.GridLineColor = 255 var_Level1.GridLineStyle = 32 var_Chart.Bars.Item("Task").Pattern = 1 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/05/2001},"A") var_Items.AddBar(h,"Task",{01/08/2001},{01/15/2001},"B") oG2antt.EndUpdate() |
1071 |
Is it possible to change the style for the grid lines, for instance to be solid not dotted
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 48 var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 48" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 48 var_Chart.LevelCount = 2 ' var_Chart.Level(1).DrawGridLines = .t. var_Level = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.DrawGridLines = True" var_Chart.Bars.Item("Task").Pattern = 1 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/05/2001},"A") var_Items.AddBar(h,"Task",{01/08/2001},{01/15/2001},"B") oG2antt.EndUpdate() |
1070 |
How can I show the grid lines for the chart and list area
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.DrawGridLines = -1 var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 48" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.DrawGridLines = -1 var_Chart.LevelCount = 2 ' var_Chart.Level(1).DrawGridLines = .t. var_Level = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.DrawGridLines = True" var_Chart.Bars.Item("Task").Pattern = 1 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/05/2001},"A") var_Items.AddBar(h,"Task",{01/08/2001},{01/15/2001},"B") |
1069 |
In the level of the chart we are showing the week number of the year (1-53) (Week: ww). However the weeknumber isn't correct. In western Europe the week of 04/01/2010 till 10/01/2010 is weeknumber 1, however the g2antt says it's week 2
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {12/28/2009} var_Chart.LevelCount = 2 ' var_Chart.Level(0).Label = "Week: <%ww%>/<%yyyy%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `Week: <%ww%>/<%yyyy%>`" var_Chart.FirstWeekDay = 1 |
1068 |
How can I determine the current visible date range of the gantt chart area
Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",{01/02/2001},{01/06/2001}) var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/03/2001},{01/07/2001}) var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",{01/04/2001},{01/08/2001}) var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/06/2001},{01/10/2001}) ? oG2antt.Chart.StartPrintDate ? oG2antt.Chart.EndPrintDate |
1067 |
How can I change the progress bar using a spin editor using values from 0 to 100
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as P Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Items.AllowCellValueToItemBar = .t. var_Columns = oG2antt.Columns var_Columns.Add("Task") var_Column = var_Columns.Add("Percent") var_Column.Editor.EditType = 4 ' var_Column.Def(18) = 518 oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(18) = 518" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.Bars.Add("Task%Progress") var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task%Progress",{01/02/2001},{01/06/2001}) ' var_Items.CellValue(h,1) = 40 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = 40" h = var_Items.AddItem("Task 2") var_Items.AddBar(h,"Task%Progress",{01/02/2001},{01/06/2001}) ' var_Items.CellValue(h,1) = 50 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = 50" oG2antt.EndUpdate() |
1066 |
Is it possible to display the histogram for selected bars only
Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 ' var_Chart.PaneWidth(.f.) = 64 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 64" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.HistogramVisible = .t. var_Chart.HistogramView = 8 var_Chart.HistogramHeight = 32 var_Chart.Bars.Item("Task").HistogramPattern = 6 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",{01/03/2001},{01/05/2001},1) var_Items.AddBar(var_Items.AddItem("Item 2"),"Task",{01/04/2001},{01/07/2001},2) var_Items.AddBar(var_Items.AddItem("Item 3"),"Task",{01/02/2001},{01/06/2001},3) ' var_Items.ItemBar(0,2,257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,2,257) = True" ' var_Items.ItemBar(0,3,257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,3,257) = True" oG2antt.EndUpdate() |
1065 |
How can I fix a bar, so it is not selectable, moveable or resizable, fixed in other words
Dim h1 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/08/2001},"K1","Unselectable") ' var_Items.ItemBar(h1,"K1",29) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,29) = False" oG2antt.EndUpdate() |
1064 |
How can I fix a bar, so it is not moveable or resizable
Dim h1 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1","Fixed") ' var_Items.ItemBar(h1,"K1",10) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,10) = False" ' var_Items.ItemBar(h1,"K1",11) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,11) = False" oG2antt.EndUpdate() |
1063 |
Is is possible to fix a bar during PDM scheduling
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"TaskF",{01/02/2001},{01/04/2001},"K1") ' var_Items.ItemBar(h1,"K1",10) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,10) = False" ' var_Items.ItemBar(h1,"K1",11) = .f. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,11) = False" h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"TaskF",{01/02/2001},{01/04/2001},"K3") ' var_Items.ItemBar(h3,"K3",10) = .f. oG2antt.TemplateDef = "dim var_Items,h3" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h3 oG2antt.Template = "var_Items.ItemBar(h3,`K3`,10) = False" ' var_Items.ItemBar(h3,"K3",11) = .f. oG2antt.TemplateDef = "dim var_Items,h3" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h3 oG2antt.Template = "var_Items.ItemBar(h3,`K3`,11) = False" var_Items.AddLink("L2",h2,"K2",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1062 |
How can I specify that during scheduling the link, bars should be delayed, on working part
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/01/2001},{01/03/2001},"K1") ' var_Items.ItemBar(h1,"K1",20) = .t. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,20) = True" h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") ' var_Items.ItemBar(h2,"K2",20) = .t. oG2antt.TemplateDef = "dim var_Items,h2" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h2 oG2antt.Template = "var_Items.ItemBar(h2,`K2`,20) = True" var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") ' var_Items.ItemBar(h3,"K3",20) = .t. oG2antt.TemplateDef = "dim var_Items,h3" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h3 oG2antt.Template = "var_Items.ItemBar(h3,`K3`,20) = True" var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "link delays the bars<br>for <b>2</b> working days" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `link delays the bars<br>for <b>2</b> working days`" ' var_Items.Link("L2",16) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,16) = 2" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1061 |
How can I specify that during scheduling the link, bars should be delayed
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.ShowNonworkingDates = .f. var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = " Finish-Start<br>delayed <b>4</b> days" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = ` Finish-Start<br>delayed <b>4</b> days`" ' var_Items.Link("L2",17) = 4 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,17) = 4" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1060 |
The SchedulePDM method put the bars on non-working part, how can I prevent that
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") ' var_Items.ItemBar(h1,"K1",20) = .t. oG2antt.TemplateDef = "dim var_Items,h1" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h1 oG2antt.Template = "var_Items.ItemBar(h1,`K1`,20) = True" h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") ' var_Items.ItemBar(h2,"K2",20) = .t. oG2antt.TemplateDef = "dim var_Items,h2" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h2 oG2antt.Template = "var_Items.ItemBar(h2,`K2`,20) = True" var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") ' var_Items.ItemBar(h3,"K3",20) = .t. oG2antt.TemplateDef = "dim var_Items,h3" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h3 oG2antt.Template = "var_Items.ItemBar(h3,`K3`,20) = True" var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FS`" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1059 |
How can I add a SF (Start-Finish) link so activities get arranged using the SchedulePDM
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "SF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `SF`" ' var_Items.Link("L2",6) = 0 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 0" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1058 |
How can I add a SS (Start-Start) link so activities get arranged using the SchedulePDM
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "SS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `SS`" ' var_Items.Link("L2",6) = 0 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 0" ' var_Items.Link("L2",7) = 0 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 0" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1057 |
How can I add a FF (Finish-Finish) link so activities get arranged using the SchedulePDM
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {12/28/2000} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FF" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FF`" ' var_Items.Link("L2",6) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,6) = 2" ' var_Items.Link("L2",7) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,7) = 2" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1056 |
How can I add a FS (Finish-Start) link so activities get arranged using the SchedulePDM
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/05/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") ' var_Items.Link("L1",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L1`,12) = `FS`" h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/06/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") ' var_Items.Link("L2",12) = "FS" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.Link(`L2`,12) = `FS`" var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1055 |
How can I schedule activities in the project plan
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddLink("L2",h3,"K3",h2,"K2") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1054 |
How do I arrange the bars based on the links
Dim h1 as N Dim h2 as N Dim h3 as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h1 = var_Items.AddItem("Task 1") var_Items.AddBar(h1,"Task",{01/02/2001},{01/04/2001},"K1") h2 = var_Items.AddItem("Task 2") var_Items.AddBar(h2,"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddLink("L1",h1,"K1",h2,"K2") h3 = var_Items.AddItem("Task 3") var_Items.AddBar(h3,"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddLink("L2",h2,"K2",h3,"K3") var_Items.SchedulePDM(0,"K1") oG2antt.EndUpdate() |
1053 |
Is is possible to use HTML tags to display in the filter caption
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarCaption = "This is a bit of text being displayed in the filter bar." oG2antt.Columns.Add("") var_Items = oG2antt.Items var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") var_Items.AddItem("Item 3") oG2antt.EndUpdate() |
1052 |
How can I find the number of items after filtering
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("") var_Items = oG2antt.Items h = var_Items.AddItem("") ' var_Items.CellValue(h,0) = var_Items.VisibleItemCount oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = VisibleItemCount" oG2antt.EndUpdate() |
1051 |
How can I change the filter caption
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 12801 'exFilterPromptWords + exFilterPromptContainsAll oG2antt.FilterBarPromptPattern = "london robert" oG2antt.FilterBarCaption = "<r>Found: ... " var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1050 |
While using the filter prompt is it is possible to use wild characters
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 16 oG2antt.FilterBarPromptPattern = "lon* seat*" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1049 |
How can I list all items that contains any of specified words, not necessary at the beggining
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 4610 'exFilterPromptStartWords + exFilterPromptContainsAny oG2antt.FilterBarPromptPattern = "london davolio" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1048 |
How can I list all items that contains any of specified words, not strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 12802 'exFilterPromptWords + exFilterPromptContainsAny oG2antt.FilterBarPromptPattern = "london nancy" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1047 |
How can I list all items that contains all specified words, not strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 12801 'exFilterPromptWords + exFilterPromptContainsAll oG2antt.FilterBarPromptPattern = "london robert" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1046 |
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 258 'exFilterPromptCaseSensitive + exFilterPromptContainsAny oG2antt.FilterBarPromptPattern = "Anne" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1045 |
Is it possible to list only items that ends with any of specified strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 4 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "Fuller" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1044 |
Is it possible to list only items that ends with any of specified strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 4 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "Fuller" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1043 |
Is it possible to list only items that starts with any of specified strings
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 3 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "An M" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1042 |
Is it possible to list only items that starts with specified string
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 3 oG2antt.FilterBarPromptColumns = "0" oG2antt.FilterBarPromptPattern = "A" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1041 |
How can I specify that the list should include any of the seqeunces in the pattern
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 2 oG2antt.FilterBarPromptPattern = "london seattle" ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1040 |
How can I specify that all sequences in the filter pattern must be included in the list
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptType = 1 oG2antt.FilterBarPromptPattern = "london manager" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1039 |
How do I change at runtime the filter prompt
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptPattern = "london manager" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1038 |
How do I specify to filter only a single column when using the filter prompt
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPromptColumns = "2,3" oG2antt.FilterBarPromptPattern = "london" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1037 |
How do I change the prompt or the caption being displayed in the filter bar
Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. oG2antt.FilterBarPrompt = "changed" var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") oG2antt.EndUpdate() |
1036 |
How do I enable the filter prompt feature
Dim h0 as N Dim oG2antt as P Dim var_Chart as local Dim var_Column as local Dim var_Column1 as local Dim var_Columns as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Chart.PaneWidth(.t.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(True) = 0" oG2antt.ColumnAutoResize = .t. oG2antt.ContinueColumnScroll = .f. oG2antt.FocusColumnIndex = 1 oG2antt.MarkSearchColumn = .f. oG2antt.SearchColumnIndex = 1 oG2antt.FilterBarPromptVisible = .t. var_Columns = oG2antt.Columns ' var_Columns.Add("Name").Width = 96 var_Column = var_Columns.Add("Name") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 96" ' var_Columns.Add("Title").Width = 96 var_Column1 = var_Columns.Add("Title") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Width = 96" var_Columns.Add("City") var_Items = oG2antt.Items h0 = var_Items.AddItem("Nancy Davolio") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Andrew Fuller") ' var_Items.CellValue(h0,1) = "Vice President, Sales" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Vice President, Sales`" ' var_Items.CellValue(h0,2) = "Tacoma" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Tacoma`" ' var_Items.SelectItem(h0) = .t. oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.SelectItem(h0) = True" h0 = var_Items.AddItem("Janet Leverling") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Kirkland" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Kirkland`" h0 = var_Items.AddItem("Margaret Peacock") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "Redmond" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Redmond`" h0 = var_Items.AddItem("Steven Buchanan") ' var_Items.CellValue(h0,1) = "Sales Manager" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Manager`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Michael Suyama") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Robert King") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" h0 = var_Items.AddItem("Laura Callahan") ' var_Items.CellValue(h0,1) = "Inside Sales Coordinator" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Inside Sales Coordinator`" ' var_Items.CellValue(h0,2) = "Seattle" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `Seattle`" h0 = var_Items.AddItem("Anne Dodsworth") ' var_Items.CellValue(h0,1) = "Sales Representative" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,1) = `Sales Representative`" ' var_Items.CellValue(h0,2) = "London" oG2antt.TemplateDef = "dim var_Items,h0" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h0 oG2antt.Template = "var_Items.CellValue(h0,2) = `London`" oG2antt.EndUpdate() |
1035 |
How can I unselect all bars
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",{01/02/2001},{01/04/2001},"K1") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"K2") var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"K4") ' var_Items.ItemBar(0,"<*>",257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,257) = True" ' var_Items.ItemBar(0,"<*>",257) = .f. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,257) = False" |
1034 |
Can I select bars using a pattern using wild characters as *,
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.ShowNonworkingDates = .f. var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1K","K1K") var_Items.AddBar(h,"Task",{01/05/2001},{01/07/2001},"K2M","K2M") var_Items.AddBar(h,"Task",{01/09/2001},{01/11/2001},"K3K","K3K") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"Q","Q") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"M","M") ' var_Items.ItemBar(0,"<K*K>",257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<K*K>`,257) = True" |
1033 |
How can I select all bars in the item with a specified key
Dim h as N Dim oG2antt as P Dim var_Chart as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} ' oG2antt.Chart.PaneWidth(.f.) = 48 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1","K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/07/2001},"K2","K2") var_Items.AddBar(h,"Task",{01/09/2001},{01/11/2001},"P","P") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"Q","Q") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"M","M") ' var_Items.ItemBar(h,"<K*>",257) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`<K*>`,257) = True" |
1032 |
How can I select all bars in the specified item
Dim h as N Dim oG2antt as P Dim var_Chart as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} ' oG2antt.Chart.PaneWidth(.f.) = 48 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1","K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/07/2001},"K2","K2") var_Items.AddBar(h,"Task",{01/09/2001},{01/11/2001},"P","P") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"Q","Q") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"M","M") ' var_Items.ItemBar(h,"<*>",257) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`<*>`,257) = True" |
1031 |
How can I select all bars with a specified key
Dim h as N Dim oG2antt as P Dim var_Chart as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} ' oG2antt.Chart.PaneWidth(.f.) = 48 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1","K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/07/2001},"K2","K2") var_Items.AddBar(h,"Task",{01/08/2001},{01/10/2001},"P","P") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"Q","Q") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"P","P") ' var_Items.ItemBar(0,"<P>",257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<P>`,257) = True" |
1030 |
How can I select all bars
Dim h as N Dim oG2antt as P Dim var_Chart as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} ' oG2antt.Chart.PaneWidth(.f.) = 48 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1","K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/07/2001},"K2","K2") var_Items.AddBar(h,"Task",{01/08/2001},{01/10/2001},"P","P") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"Q","Q") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"M","M") ' var_Items.ItemBar(0,"<*>",257) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBar(0,`<*>`,257) = True" |
1029 |
I have the AllowInsideZoom property on True, but I am still not able to use the inside zoom feature
Dim oG2antt as P Dim var_Chart as P Dim var_InsideZoomFormat as P Dim var_Level as local Dim var_Level1 as P Dim var_Level2 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 0" var_Chart.LevelCount = 3 var_Chart.FirstWeekDay = 1 ' var_Chart.Level(0).Label = "Week: <%ww%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `Week: <%ww%>`" var_Level1 = var_Chart.Level(1) var_Level1.Label = "<%dddd%>" var_Level1.Alignment = 1 ' var_Chart.Level(2).Label = 65536 var_Level2 = var_Chart.Level(2) oG2antt.TemplateDef = "dim var_Level2" oG2antt.TemplateDef = var_Level2 oG2antt.Template = "var_Level2.Label = 65536" var_Chart.NonworkingHours = 16773375 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. var_Chart.ShowNonworkingHours = .f. var_Chart.AllowInsideZoom = .t. var_InsideZoomFormat = var_Chart.DefaultInsideZoomFormat var_InsideZoomFormat.InsideUnit = 1048576 var_InsideZoomFormat.InsideLabel = "<b><%nn%></b>" var_Chart.InsideZooms.Add({01/01/2001 10:00:00}) oG2antt.EndUpdate() |
1028 |
Is there any option to find out if two bars intersects
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.DefaultItemHeight = 22 oG2antt.Columns.Add("InterectBars") var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.Bars.Item("Task").OverlaidType = 1 var_Items = oG2antt.Items h = var_Items.AddItem("") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"A","A") var_Items.AddBar(h,"Task",{01/03/2001},{01/05/2001},"B","B") ' var_Items.CellValue(h,0) = var_Items.IntersectBars(h,"A",h,"B") oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = IntersectBars(h,`A`,h,`B`)" h = var_Items.AddItem("") var_Items.AddBar(h,"Task",{01/06/2001},{01/09/2001},"A","A") var_Items.AddBar(h,"Task",{01/10/2001},{01/13/2001},"B","B") ' var_Items.CellValue(h,0) = var_Items.IntersectBars(h,"A",h,"B") oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = IntersectBars(h,`A`,h,`B`)" h = var_Items.AddItem("") var_Items.AddBar(h,"Task",{01/06/2001},{01/09/2001},"B","B") var_Items.AddBar(h,"Task",{01/10/2001},{01/13/2001},"A","A") ' var_Items.CellValue(h,0) = var_Items.IntersectBars(h,"A",h,"B") oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = IntersectBars(h,`A`,h,`B`)" oG2antt.EndUpdate() |
1027 |
How can I find if a specified hour is a working or non-working hour, when using the ItemNonWorkingUnits
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Hour").FormatColumn = "hour(value)" var_Column = oG2antt.Columns.Add("Hour") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.FormatColumn = `hour(value)`" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 164 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 164" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.UnitScale = 65536 var_Chart.NonworkingHours = 1 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/01/2001}) ' var_Items.ItemNonworkingUnits(h,.f.) = "hour(value) >0 " oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemNonworkingUnits(h,False) = `hour(value) >0 `" w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0),h) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1026 |
How can I find if a specified hour is a working or non-working hour
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Hour").FormatColumn = "hour(value)" var_Column = oG2antt.Columns.Add("Hour") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.FormatColumn = `hour(value)`" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 164 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 164" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.UnitScale = 65536 var_Chart.NonworkingHours = 1 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/01/2001 01:00:00}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1025 |
How can I find if a specified date-time is a working or non-working unit, when using the ItemNonWorkingUnits
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Date").Width = 48 var_Column = oG2antt.Columns.Add("Date") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 48" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 128 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 128" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/01/2001}) ' var_Items.ItemNonworkingUnits(h,.f.) = "weekday(value) in (1)" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemNonworkingUnits(h,False) = `weekday(value) in (1)`" w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0),h) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1024 |
How can I find if a specified date-time is a working or non-working unit
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim w as oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() ' oG2antt.Columns.Add("Date").Width = 48 var_Column = oG2antt.Columns.Add("Date") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 48" ' oG2antt.Columns.Add("Type").FormatColumn = "value != 0 ? 'non-working' : 'working'" var_Column1 = oG2antt.Columns.Add("Type") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.FormatColumn = `value != 0 ? 'non-working' : 'working'`" var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 128 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 128" var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Items = oG2antt.Items h = var_Items.AddItem({01/01/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" h = var_Items.AddItem({01/06/2001}) w = oG2antt.Chart.IsNonworkingDate(oG2antt.Items.CellValue(h,0)) ' var_Items.CellValue(h,1) = w oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = w" oG2antt.EndUpdate() |
1023 |
When zooming to days, the non-working part of the chart occupies some not useful space. Can I reduce it
Dim h as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P Dim var_Level as local Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.FirstVisibleDate = {01/03/2002} ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.LevelCount = 2 var_Chart.DrawGridLines = -1 var_Chart.FirstWeekDay = 1 ' var_Chart.Level(0).Label = "Week: <%ww%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `Week: <%ww%>`" var_Level1 = var_Chart.Level(1) var_Level1.Label = "<%d%>/<%m2%>" var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? 'end' : value" var_Chart.UnitWidth = 32 var_Chart.UnitWidthNonworking = -32 oG2antt.Columns.Add("Task") var_Items = oG2antt.Items h = var_Items.AddItem("Default") var_Items.AddBar(h,"Task",{01/04/2002},{01/08/2002},"A") oG2antt.EndUpdate() |
1022 |
My chart display only working hours, but when zooming to days, each day shows the non-working part of the day too, even if I use the ShowNonWorkingUnits property on False. What am I doing wrong
Dim h as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P Dim var_Level as local Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.FirstVisibleDate = {01/03/2002 10:00:00} ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.LevelCount = 2 var_Chart.DrawGridLines = -1 var_Chart.FirstWeekDay = 1 ' var_Chart.Level(0).Label = "<%ww%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%ww%>`" var_Level1 = var_Chart.Level(1) var_Level1.Label = "<%dd%>" var_Level1.Unit = 65536 var_Level1.Count = 24 var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidth = 32 oG2antt.Columns.Add("Task") var_Items = oG2antt.Items h = var_Items.AddItem("Default") var_Items.AddBar(h,"Task",{01/04/2002 10:00:00},{01/08/2002 02:00:00},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" oG2antt.EndUpdate() |
1021 |
I need to display only working hours and weekend part, but for some items I need another non-working part. Is this possible
Dim h as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.FirstVisibleDate = {01/03/2002} ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.LevelCount = 2 var_Chart.DrawGridLines = -1 var_Level = var_Chart.Level(0) var_Level.Label = "<%ddd%>" var_Level.FormatLabel = "weekday(dvalue) in (0,6) ? '' : value" var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? 'end' : value" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidthNonworking = -24 oG2antt.Columns.Add("Task") var_Items = oG2antt.Items h = var_Items.AddItem("Default") var_Items.AddBar(h,"Task",{01/04/2002},{01/08/2002},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" h = var_Items.AddItem("Friday") var_Items.AddBar(h,"Task",{01/03/2002},{01/07/2002 12:00:00},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" ' var_Items.ItemNonworkingUnits(h,.f.) = "weekday(value) in (0,6,5) or hour(value)<10 or hour(value)>=14" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemNonworkingUnits(h,False) = `weekday(value) in (0,6,5) or hour(value)<10 or hour(value)>=14`" h = var_Items.AddItem("Till 13") var_Items.AddBar(h,"Task",{01/04/2002},{01/07/2002 12:00:00},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" ' var_Items.ItemNonworkingUnits(h,.f.) = "weekday(value) in (0,6) or hour(value)<10 or hour(value)>=13" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemNonworkingUnits(h,False) = `weekday(value) in (0,6) or hour(value)<10 or hour(value)>=13`" oG2antt.EndUpdate() |
1020 |
I can display the working hours, but how can I hide the weekend or non-working part of the chart when using the ShowNonWorkingUnits property on False
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local Dim var_Level1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.LevelCount = 2 ' var_Chart.Level(0).Label = "<%ddd%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%ddd%>`" ' var_Chart.Level(1).Label = 65536 var_Level1 = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level1" oG2antt.TemplateDef = var_Level1 oG2antt.Template = "var_Level1.Label = 65536" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. var_Chart.ShowNonworkingHours = .f. |
1019 |
How can I display only the working hours but uses less space for non-working part, such as weekend
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.Label = "<%ddd%>" var_Level.FormatLabel = "weekday(dvalue) in (0,6) ? '' : value" var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? 'end' : value" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidthNonworking = -24 |
1018 |
How can I display only the working hours but uses less space for non-working part, such as weekend
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.LevelCount = 2 ' var_Chart.Level(0).Label = "<%ddd%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%ddd%>`" var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? '' : value" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidthNonworking = 8 |
1017 |
How can I display only the working hours
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local Dim var_Level1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.LevelCount = 2 ' var_Chart.Level(0).Label = "<%ddd%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%ddd%>`" ' var_Chart.Level(1).Label = 65536 var_Level1 = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level1" oG2antt.TemplateDef = var_Level1 oG2antt.Template = "var_Level1.Label = 65536" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingHours = .f. |
1016 |
How can I specify non-working hours
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local Dim var_Level1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.LevelCount = 2 ' var_Chart.Level(0).Label = "<%ddd%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%ddd%>`" ' var_Chart.Level(1).Label = 65536 var_Level1 = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level1" oG2antt.TemplateDef = var_Level1 oG2antt.Template = "var_Level1.Label = 65536" var_Chart.NonworkingHours = 16761855 |
1015 |
How can I display the working hours for a bar
Dim h as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Column as P Dim var_Columns as P Dim var_Items as P Dim var_Level as local Dim var_Level1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Columns = oG2antt.Columns var_Columns.Add("Tasks") var_Column = var_Columns.Add("Working") ' var_Column.Def(18) = 258 oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(18) = 258" ' var_Column.Def(19) = "A" oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(19) = `A`" var_Column.FormatColumn = "(0:=round(value*24)) != 0 ? =:0 : ''" oG2antt.Items.AllowCellValueToItemBar = .t. var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 96 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 96" ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.LevelCount = 2 ' var_Chart.Level(0).Label = "<%ddd%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%ddd%>`" ' var_Chart.Level(1).Label = "<%hh%>" var_Level1 = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level1" oG2antt.TemplateDef = var_Level1 oG2antt.Template = "var_Level1.Label = `<%hh%>`" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingHours = .f. var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/04/2002},{01/08/2002},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" h = var_Items.AddItem("Task 2") var_Items.AddBar(h,"Task",{01/03/2002},{01/04/2002},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" oG2antt.EndUpdate() |
1014 |
Is it possible to show only working hours, showing a small part for the weekend days, and in the same time showing the bars by splitting the non-working part and keeping the working units for the bar while moving
Dim h as N Dim oG2antt as P Dim var_Bar as local Dim var_Chart as P Dim var_Items as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.Bars.Add("Task:Split").Shortcut = "Task" var_Bar = var_Chart.Bars.Add("Task:Split") oG2antt.TemplateDef = "dim var_Bar" oG2antt.TemplateDef = var_Bar oG2antt.Template = "var_Bar.Shortcut = `Task`" var_Chart.FirstVisibleDate = {01/03/2002} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 512 ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 0" var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.Label = "<%ddd%>" var_Level.Alignment = 1 var_Level.FormatLabel = "weekday(dvalue) in (0,6) ? `` : value" var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.DrawGridLines = .t. var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? `<font ;6>weekend</font>` : value" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .t. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidthNonworking = -40 oG2antt.Columns.Add("Task") var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/04/2002},{01/08/2002},"A") ' var_Items.ItemBar(h,"A",20) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,20) = True" oG2antt.EndUpdate() |
1013 |
How can I show bars with different solid color but black border
Dim h as N Dim oG2antt as P Dim var_Bar as P Dim var_Chart as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.VisualAppearance.Add(1,"C:\Program Files\Exontrol\ExG2antt.NET\sample\EBN\blackbox.ebn") oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = {01/01/2001} var_Bar = oG2antt.Chart.Bars.Item("Task") var_Bar.Color = 16777216 var_Bar.Height = 15 ' oG2antt.Chart.PaneWidth(.f.) = 0 var_Chart = oG2antt.Chart oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Items = oG2antt.Items h = var_Items.AddItem("Task") var_Items.AddBar(h,"Task",{01/02/2001},{01/05/2001},"") ' var_Items.ItemBar(h,"",33) = 65535 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,``,33) = 65535" h = var_Items.AddItem("Task") var_Items.AddBar(h,"Task",{01/02/2001},{01/05/2001},"") ' var_Items.ItemBar(h,"",33) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,``,33) = 255" oG2antt.EndUpdate() |
1012 |
I want to display a vertical line for each week, while I still need a vertical separator for each day. Is this possible
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.GridLineColor = 15790320 var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.DrawGridLines = -1 var_Chart.NonworkingDays = 0 var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.DrawGridLines = .t. var_Level.GridLineColor = 0 var_Level1 = var_Chart.Level(1) var_Level1.DrawGridLines = .t. var_Level1.GridLineColor = 15790320 |
1011 |
How can I display the levels as year, day, AM and PM for each day
Dim oG2antt as P Dim var_Chart as P Dim var_Level as local Dim var_Level1 as local Dim var_Level2 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {12/01/2009} var_Chart.UnitWidth = 22 var_Chart.LevelCount = 3 ' var_Chart.Level(0).Label = "<%yyyy%>" var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.Label = `<%yyyy%>`" ' var_Chart.Level(1).Label = "<%mm%>/<%dd%>" var_Level1 = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level1" oG2antt.TemplateDef = var_Level1 oG2antt.Template = "var_Level1.Label = `<%mm%>/<%dd%>`" var_Level2 = var_Chart.Level(2) var_Level2.Label = "<%AM/PM%>" var_Level2.Count = 12 |
1010 |
How can I change the pattern for a specified time unit, in the chart area
Dim oG2antt as P Dim var_Chart as P Dim var_InsideZoom as local Dim var_InsideZoomFormat as P Dim var_InsideZooms as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = {01/01/2008} var_Chart.AllowInsideZoom = .t. var_Chart.AllowResizeInsideZoom = .f. var_Chart.InsideZoomOnDblClick = .f. var_InsideZoomFormat = var_Chart.DefaultInsideZoomFormat var_InsideZoomFormat.PatternChart = 6 var_InsideZoomFormat.PatternColorChart = 255 var_InsideZooms = var_Chart.InsideZooms var_InsideZooms.SplitBaseLevel = .f. var_InsideZooms.DefaultWidth = 18 ' var_InsideZooms.Add({01/04/2008}).AllowInsideFormat = .f. var_InsideZoom = var_InsideZooms.Add({01/04/2008}) oG2antt.TemplateDef = "dim var_InsideZoom" oG2antt.TemplateDef = var_InsideZoom oG2antt.Template = "var_InsideZoom.AllowInsideFormat = False" oG2antt.EndUpdate() |
1009 |
How can I hide the non-working hours, but still display the non-working days with even less space
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {11/19/2009} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 512 ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 0" var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.Label = "<%dddd%>" var_Level.Alignment = 1 var_Level.FormatLabel = "weekday(dvalue) in (0,6) ? `` : value" var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.DrawGridLines = .t. var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? `<font ;6>weekend</font>` : value" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .t. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidth = 32 var_Chart.UnitWidthNonworking = -32 oG2antt.EndUpdate() |
1008 |
How can I hide the non-working hours, but still display the non-working days with less space
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {11/19/2009} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 512 ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 0" var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.Label = "<%dddd%>" var_Level.Alignment = 1 var_Level.FormatLabel = "weekday(dvalue) in (0,6) ? `<font ;6>` + value + `</font>` : value" var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.DrawGridLines = .t. var_Level1.FormatLabel = "weekday(dvalue) in (0,6) ? `<font ;6>` + value + `</font>` : value" var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .t. var_Chart.ShowNonworkingHours = .f. var_Chart.UnitWidth = 32 var_Chart.UnitWidthNonworking = 12 oG2antt.EndUpdate() |
1007 |
How can I hide the non-working hours, but still display the non-working days
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {11/19/2009} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 512 ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 0" var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.Label = "<%dddd%>" var_Level.Alignment = 1 var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.DrawGridLines = .t. var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .t. var_Chart.ShowNonworkingHours = .f. oG2antt.EndUpdate() |
1006 |
How can I hide the non-working hours, and the non-working days
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P Dim var_Level1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = {11/19/2009} var_Chart.DrawGridLines = -1 var_Chart.GridLineStyle = 512 ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(0) = 0" var_Chart.LevelCount = 2 var_Level = var_Chart.Level(0) var_Level.Label = "<%dddd%>" var_Level.Alignment = 1 var_Level1 = var_Chart.Level(1) var_Level1.Label = 65536 var_Level1.DrawGridLines = .t. var_Chart.NonworkingHours = 16761855 var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. var_Chart.ShowNonworkingHours = .f. oG2antt.EndUpdate() |
1005 |
Can I highlights the non-working hours while my chart shows days
Dim oG2antt as P Dim var_Chart as P Dim var_Level as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 0 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 0" var_Chart.FirstVisibleDate = {01/01/2001} var_Chart.UnitWidth = 48 var_Chart.LevelCount = 2 var_Level = var_Chart.Level(1) var_Level.Label = "<%d%>" var_Level.Unit = 65536 var_Level.Count = 24 var_Chart.NonworkingHours = 127 |
1004 |
How can I reduce the space/area being occupied by non-working units days or hours (method 2)
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 64 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 64" var_Chart.UnitWidthNonworking = -8 ' var_Chart.Level(1).FormatLabel = "weekday(dvalue) in (0,6) ? '.' : value" var_Level = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.FormatLabel = `weekday(dvalue) in (0,6) ? '.' : value`" var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/06/2001},"K2") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"K4") ' var_Items.ItemBar(h,"<*>",33) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`<*>`,33) = 255" oG2antt.EndUpdate() |
1003 |
How can I reduce the space/area being occupied by non-working units days or hours (method 1)
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 64 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 64" var_Chart.UnitWidthNonworking = 4 ' var_Chart.Level(1).FormatLabel = "weekday(dvalue) in (0,6) ? '' : value" var_Level = var_Chart.Level(1) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.FormatLabel = `weekday(dvalue) in (0,6) ? '' : value`" var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/06/2001},"K2") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"K4") ' var_Items.ItemBar(h,"<*>",33) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`<*>`,33) = 255" oG2antt.EndUpdate() |
1002 |
How can I hide the non-working units
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P Dim var_Level as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = {01/01/2001} ' var_Chart.PaneWidth(.f.) = 64 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 64" var_Chart.ShowNonworkingUnits = .f. var_Chart.ShowNonworkingDates = .f. var_Chart.DrawGridLines = 2 ' var_Chart.Level(0).DrawGridLines = .t. var_Level = var_Chart.Level(0) oG2antt.TemplateDef = "dim var_Level" oG2antt.TemplateDef = var_Level oG2antt.Template = "var_Level.DrawGridLines = True" var_Chart.GridLineStyle = 512 var_Items = oG2antt.Items h = var_Items.AddItem("Task 1") var_Items.AddBar(h,"Task",{01/02/2001},{01/04/2001},"K1") var_Items.AddBar(h,"Task",{01/05/2001},{01/06/2001},"K2") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",{01/02/2001},{01/04/2001},"K3") var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",{01/02/2001},{01/04/2001},"K4") ' var_Items.ItemBar(h,"<*>",33) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`<*>`,33) = 255" oG2antt.EndUpdate() |
1001 |
How can I determine that a certain bar is the topmost (zorder)
Dim h as N Dim oG2antt as P Dim var_Chart as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart ' var_Chart.PaneWidth(.f.) = 48 oG2antt.TemplateDef = "dim var_Chart" oG2antt.TemplateDef = var_Chart oG2antt.Template = "var_Chart.PaneWidth(False) = 48" var_Chart.FirstVisibleDate = {12/27/2000} var_Chart.Bars.Item("Task").Pattern = 1 var_Items = oG2antt.Items h = var_Items.AddItem("B in front") var_Items.AddBar(h,"Task",{01/02/2001},{01/06/2001},"A") var_Items.AddBar(h,"Task",{01/03/2001},{01/05/2001},"B","<fgcolor=FF0000>B</fgcolor>") ' var_Items.ItemBar(h,"B",18) = -2 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`B`,18) = -2" ' var_Items.ItemBar(h,"B",4) = 18 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`B`,4) = 18" ' var_Items.ItemBar(h,"B",33) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`B`,33) = 255" h = var_Items.AddItem("A in back") var_Items.AddBar(h,"Task",{01/02/2001},{01/06/2001},"A","<fgcolor=FF0000>A</fgcolor>") ' var_Items.ItemBar(h,"A",18) = -2 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,18) = -2" ' var_Items.ItemBar(h,"A",4) = 18 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,4) = 18" ' var_Items.ItemBar(h,"A",33) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemBar(h,`A`,33) = 255" var_Items.AddBar(h,"Task",{01/03/2001},{01/05/2001},"B") oG2antt.EndUpdate() |